Jassif Team Institution

let mysql = require('mysql');

let con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  let sql = "INSERT INTO customers (name, address) VALUES ('Company Inc', 'Highway 37')";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("1 record inserted");
  });
});

C:\Users\Your Name>node demo_db_insert.js

Connected!
1 record inserted

let mysql = require('mysql');

let con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  let sql = "INSERT INTO customers (name, address) VALUES ?";
  let values = [
    ['John', 'Highway 71'],
    ['Peter', 'Lowstreet 4'],
    ['Amy', 'Apple st 652'],
    ['Hannah', 'Mountain 21'],
    ['Michael', 'Valley 345'],
    ['Sandy', 'Ocean blvd 2'],
    ['Betty', 'Green Grass 1'],
    ['Richard', 'Sky st 331'],
    ['Susan', 'One way 98'],
    ['Vicky', 'Yellow Garden 2'],
    ['Ben', 'Park Lane 38'],
    ['William', 'Central st 954'],
    ['Chuck', 'Main Road 989'],
    ['Viola', 'Sideway 1633']
  ];
  con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });
});

C:\Users\Your Name>node demo_db_insert_multiple.js

Connected!
Number of records inserted: 14

{
  fieldCount: 0,
  affectedRows: 14,
  insertId: 0,
  serverStatus: 2,
  warningCount: 0,
  message: '\'Records:14  Duplicated: 0  Warnings: 0',
  protocol41: true,
  changedRows: 0
}

console.log(result.affectedRows)

14

let mysql = require('mysql');

let con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "mydb"
});

con.connect(function(err) {
  if (err) throw err;
  let sql = "INSERT INTO customers (name, address) VALUES ('Michelle', 'Blue Village 1')";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("1 record inserted, ID: " + result.insertId);
  });
});

C:\Users\Your Name>node demo_db_insert_id.js

1 record inserted, ID: 15

const name = "John Doe";
const address = "123 Main Street";
const sql = "INSERT INTO customers (name, address) VALUES (?, ?)";
con.query(sql, [name, address], function (err, result) {
  if (err) throw err;
  console.log("Record inserted with ID: " + result.insertId);
});

con.query("INSERT INTO customers (name, address) VALUES (?, ?)", 
  ["John", "123 Street"], 
  function (err, result) {
    if (err) {
      console.error("Error inserting record:", err.message);
      return;
    }
    console.log("Record inserted successfully. ID:", result.insertId);
  }
);

// Insert into multiple tables
const customerSQL = "INSERT INTO customers (name, email) VALUES (?, ?)";
const orderSQL = "INSERT INTO orders (customer_id, amount) VALUES (?, ?)";

con.query(customerSQL, ["John", "john@example.com"], function (err, result) {
  if (err) throw err;
  const customerId = result.insertId;
  
  // Now insert into orders table
  con.query(orderSQL, [customerId, 100.50], function (err, result) {
    if (err) throw err;
    console.log("Customer and order created successfully");
  });
});

const mysql = require('mysql');

// Create connection
const con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  database: "company_db"
});

// Connect to MySQL
con.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err.message);
    return;
  }
  
  console.log('Connected to MySQL database');
  
  // Single record insertion
  const singleRecordSQL = "INSERT INTO employees (first_name, last_name, email, salary) VALUES (?, ?, ?, ?)";
  const singleValues = ["John", "Doe", "john.doe@company.com", 50000.00];
  
  con.query(singleRecordSQL, singleValues, (err, result) => {
    if (err) {
      console.error('Error inserting single record:', err.message);
      con.end();
      return;
    }
    
    console.log(`Single record inserted with ID: ${result.insertId}`);
    
    // Multiple records insertion
    const multipleRecordsSQL = "INSERT INTO employees (first_name, last_name, email, salary) VALUES ?";
    const multipleValues = [
      ["Jane", "Smith", "jane.smith@company.com", 55000.00],
      ["Bob", "Johnson", "bob.johnson@company.com", 60000.00],
      ["Alice", "Brown", "alice.brown@company.com", 52000.00]
    ];
    
    con.query(multipleRecordsSQL, [multipleValues], (err, result) => {
      if (err) {
        console.error('Error inserting multiple records:', err.message);
        con.end();
        return;
      }
      
      console.log(`Multiple records inserted. Affected rows: ${result.affectedRows}`);
      
      // Show all employees
      con.query("SELECT * FROM employees", (err, results) => {
        if (err) {
          console.error('Error fetching employees:', err.message);
          con.end();
          return;
        }
        
        console.log('\nAll employees:');
        results.forEach(employee => {
          console.log(`ID: ${employee.id}, Name: ${employee.first_name} ${employee.last_name}, Email: ${employee.email}, Salary: ${employee.salary}`);
        });
        
        // Close connection
        con.end((err) => {
          if (err) {
            console.error('Error closing connection:', err.message);
            return;
          }
          console.log('\nConnection closed');
        });
      });
    });
  });
});